<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;

class CreateYsNoticeTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('notice', function(Blueprint $table)
		{
			$table->increments('id')->comment('主键id');
			$table->string('title', 32)->nullable()->comment('标题');
			$table->text('content')->nullable()->comment('公告内容');
			$table->integer('put_time')->nullable()->comment('发布时间');
			$table->integer('end_time')->nullable()->comment('结束时间');
			$table->tinyInteger('status')->nullable()->comment('发布状态0为正常1为结束');
		});
	}


	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('notice');
	}

}
